<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<meta http-equiv="Content-Style-Type" content="text/css" />
				<title>1.7&#xa0;&#xa0;&#xa0; DBLINK管理</title>
		<link href="xcloud-sqldeveloper-helper.css" type="text/css" rel="stylesheet" />
	</head>
	<body><h2 style="margin-left:57.15pt; text-indent:-28.8pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.7</span><span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0; </span><a name="_Toc443396596">DBLINK管理</a></h2>
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.7.1</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396597">新建Oracle DBLINK</a></h3>
			<p style="text-indent:0pt">  ①、右键单击OracleDblink,出现新建Oracle Dblink菜单，如下图：</p>
			<p style="text-indent:0pt; text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.144.png" width="458" height="382" alt="" />
			</p>
			<p>②、单击新建Oracle Dblink，弹出Dblink编辑面板,添加Dblink名称，sid，用户名和密码属性，如下图</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.145.png" width="525" height="394" alt="" />
			</p>
			<p>③、点击查看sql ，弹出新建Oracle Dblink脚本面板，如下图</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.146.png" width="694" height="603" alt="" />
			</p>
			<p>单击复制，脚本自动复制到系统粘贴板上</p>
			<p>&#xa0;</p>
			<p style="text-indent:0pt">④、点击完成，实现Dblink的创建</p>
			<p style="text-indent:0pt; text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.147.png" width="197" height="69" alt="" />
			</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.7.2</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396597">新建Mysql DBLINK</a></h3>
			<p style="text-indent:0pt">  ①、右键单击MysqlDblink,出现新建Mysql Dblink菜单，如下图：</p>
			<p style="text-indent:0pt; text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.144_1.png" width="412" height="386" alt="" />
			</p>
			<p>②、单击新建Mysql Dblink，弹出Dblink编辑面板,添加Dblink名称，sid，用户名和密码属性，如下图</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.145_1.png" width="525" height="394" alt="" />
			</p>
			<p>③、点击查看sql ，弹出新建Mysql Dblink脚本面板，如下图</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.146_1.png" width="694" height="603" alt="" />
			</p>
			<p>单击复制，脚本自动复制到系统粘贴板上</p>
			<p>&#xa0;</p>
			<p style="text-indent:0pt">④、点击完成，实现Dblink的创建</p>
			<p style="text-indent:0pt; text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.147_1.png" width="222" height="82" alt="" />
			</p>
			<p>&#xa0;</p>
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.7.3</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396599">Dblink刷新</a></h3>
			<p>①、右键Dblink节点出现刷新菜单，或右键MysqlDblink与OracleDblink出现各自刷新菜单，如图：</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.151.png" width="407" height="389" alt="" />
			</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.151_1.png" width="390" height="250" alt="" />
			</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.151_2.png" width="423" height="319" alt="" />
			</p>
			<p>②、右键单击刷新，进行Dblink的刷新</p>
			<p style="text-indent:0pt; text-align:center">&#xa0;</p>
			<h3 style="margin-left:36pt; text-indent:-36pt"><span style="font-style:normal; font-variant:normal; text-decoration:none; text-transform:none; letter-spacing:0pt; vertical-align:0pt">1.7.4</span><span style="font:7.0pt 'Times New Roman'">&#xa0; </span><a name="_Toc443396600">DBlink操作</a></h3>
			<h4 style="margin-left:92.85pt; text-indent:-43.2pt">1.7.4.1<span style="font:7.0pt 'Times New Roman'"> </span>删除DBlink节点 </h4>
			<p style="text-indent:0pt">①、右键单击DBlink实例节点，出现删除菜单，如下图：</p>
			<p style="text-indent:0pt">&#xa0;</p>
			<p style="text-indent:0pt; text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.152.png" width="504" height="426" alt="" />
			</p>
			<p style="text-indent:0pt">②、单击删除按钮，出现信息提示，如下图：</p>
			<p style="text-indent:0pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.153.png" width="500" height="150" alt="" />
			</p>
			<p style="text-indent:0pt">③、单击查看sql，弹出删除DBlink脚本面板，如下图：</p>
			<p style="text-indent:0pt">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.154.png" width="694" height="603" alt="" />
			</p>
			<p style="text-indent:0pt">单击复制，脚本自动复制到系统粘贴板上</p>
			<p style="text-indent:0pt">④、点击确定按钮，删除DBlink节点，如下图：</p>
			<p style="text-indent:0pt; text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.155.png" width="158" height="69" alt="" />
			</p>
			<h4 style="margin-left:92.85pt; text-indent:-92.85pt">1.7.4.2<span style="font:7.0pt 'Times New Roman'">&#xa0;&#xa0;&#xa0;&#xa0; </span>刷新DBlink节点</h4>
			<p>①、右键Dblink节点出现刷新菜单如图：</p>
			<p style="text-align:center">
				<img src="xcloud-sqldeveloper-helper/xcloud-sqldeveloper-helper.156.png" width="453" height="225" alt="" />
			</p>
			<p>②、右键单击刷新，进行Dblink的刷新</p>
			</body>
</html>